USE [CTEM-DB-v1]
GO

/****** Object:  StoredProcedure [dbo].[Worker_Update]    Script Date: 02/10/2012 11:15:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



-- =============================================
-- Author:		TienDH
-- Create date: 12/05/2011
-- Description:	Get full employee's information
-- =============================================
CREATE PROCEDURE [dbo].[Worker_Update]
    @WorkerID		        bigint,
	@FullName				nvarchar(50),
	@ManDate				float,
	@Salary					bigint,
	@TotalSalary			bigint,
	@Position				nvarchar(125)
AS

BEGIN
	EXEC DayWorking_Delete @WorkerID
	UPDATE  [Worker]
			
	SET    
			FullName = @FullName,
			ManDate = @ManDate,
			Salary = @Salary,
			TotalSalary =@TotalSalary,
			Position = @Position

			
			
	WHERE	WorkerID = @WorkerID
END



GO

